 |
Create a better InStr function with VBScript regular expressions
|
| Total Hit (14971) |
Regular expressions offer an extremely powerful way to search and replace text inside a string using sophisticated search criteria, far behind the capabilities of VB's InStr and Replace functions. For example, you can search for whole words, or find a match with a range of characters (for example, a
....Read More |
Rating
 |
|
 |
TrimEx function using Regular Expression.
|
| Total Hit (3166) |
Regular Trim function only removes preceding and trailing space but it does not remove all other white space characters e.g. New Line(\n), Carraige return(\r), Form Feed(\f), Tab(\t). To remove these characters you can easily implement function using Regular expression.
....Read More |
| Rating
|
|
|
|
 |
Test your Search and replace Regular Expression
|
| Total Hit (2672) |
Test your Regular expression and also test Search and replace with regular expression
«b»«a href='../tools/RegTester.aspx'»Click here to see Live Demo...«/a»«/b»
«code LangId=2»<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">
....Read More |
| Rating
|
|
|
|
|
|
HTML Color Coding for various Languages (i.e. VB, VB.net, SQL).
|
| Total Hit (10639) |
I spent several hours to find some article to convert Source Code into HTML with different colorcode for keywords/literal/comment/function. But no luck and finally I wrote my own ColorCoding Engine. This article will show you how you can utilize power of Regular Expression to solve your very complex
....Read More |
Rating
 |
|
|
|
Extract all quoted strings with the RegExp object
|
| Total Hit (3622) |
When parsing a text file that contains quoted strings - such as a VB source file - you might want to quickly locate and extract all the quoted strings. Thanks to regular expressions and the RegExp object in the Microsoft VBScript Regular Expression type library, this task is surprisingly easy:
«co
....Read More |
| Rating
|
|
|
|
|
|
Automatically hyperlink URLs in ASP.NET Pages
|
| Total Hit (9776) |
Suppose that your ASP.NET pages display contents read from database fields. Suppose also that some of those fields may contain URLs or email addresses. A typical example is when you display user information such as the email address or the personal Web site. By using regular expressions, you can aut
....Read More |
Rating
 |
|
|
|
Stripping HTML Tags using Regular Expressions
|
| Total Hit (1870) |
Have you ever wanted to strip all of the HTML tags from a string? There are many reasons you may want to do this. For example, if you provide a feature on your site where a user can have the contents of a Web page emailed to them, you may wish to strip all of the HTML tags from the particular articl
....Read More |
| Rating
|
|
|
|
|
|
An Introduction to Regular Expressions and Their Use in .NET II...
|
| Total Hit (1545) |
In the first article in this series we introduced background information regarding regular expressions as well as starting to look at the support for regular expressions in .NET. In this article we'll look in more detail at this latter area.
|
| Rating
|
|
|
|
|
|
How Do I...Use common Regular Expressions?
|
| Total Hit (743) |
«b»Social Security Number «/b»
\d{3}-\d{2}-\d{4}
«b»US Phone Number«/b»
((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}
«b»US Postal Code«/b»
\d{5}(-\d{4})?
«b»Internet EMail Address«/b»
[\w-]+@([\w-]+\.)+[\w-]+
«b»Internet URL «/b»
http://([\w-]\.)+[\w-](/[\w- ./?%=]*)?
«b
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
ASP.NET Validators Unclouded
|
| Total Hit (2755) |
Demistifying the mysterious ASP.NET validator controls, allowing fast and painless validation of Web Forms.
|
| Rating
|
|
|
|
|
|
How Do I...Use Regular Expressions to match a pattern?
|
| Total Hit (764) |
Regular Expressions allow for easy parsing and matching of strings to a specific pattern. Using the objects available in the RegularExpressions namespace, it is possible to compare a string against a given pattern, replace a string pattern with another string, or to retrieve only portions of a forma
....Read More |
| Rating
|
|
|
|
DHTML Clock Control
|
| Total Hit (993) |
Digital DHTML clock that displays a .NET DateTimeFormatInfo Format Pattern.
|
| Rating
|
|
|
|
|
|
Real Time syntax highlighting [wrapper class]
|
| Total Hit (2579) |
Hello again. This time I wanted to bring you something that was really challenging for me to build. I must have tried at least four totally different solutions to this problem consuming literally days of my time until I reached the best one. At the request of our beloved staff, I will attempt to exp
....Read More |
| Rating
|
|
|
|
|
|
ASP Configuration Files
|
| Total Hit (796) |
ASP.NET/ IIS applications use an optional XML-based configuration file named web.config, to maintain application configuration settings. This extends and/ or changes any settings in the system wide configuration file, machine.config.
|
| Rating
|
|
 |
Arrays and Lists in SQL Server
|
| Total Hit (771) |
In the public forums for SQL Server, you often see people asking How do I use arrays in SQL Server? Or Why does SELECT * FROM tbl WHERE col IN (@list) not work? This text describes several methods to do this, both good and bad ones. I also present data from performance tests of the various methods.
....Read More |
| Rating
|
|
|
|
|
|
|
|
The Curse and Blessings of Dynamic SQL
|
| Total Hit (765) |
In this article I will discuss the of use dynamic SQL in stored procedures in MS SQL Server, and I will show that this is a powerful feature that you should use with care.
|
| Rating
|
|
|
|
Cubes in the Real World
|
| Total Hit (1715) |
Microsoft® SQL Server™ 2000 Analysis Services offers myriad options for creating cubes, and the flexibility and power to support almost any business case. This chapter presents practical guidelines for designing cubes and dimensions, design fundamentals, and other considerations
....Read More |
| Rating
|
|